package com.jy.adscm.hcPlan.mapper.mysql;

import com.jy.adscm.hcPlan.bean.HcPlanFinalAssembly;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Date;
import java.util.List;

/**
 * <p>
 * 耗材总装表 Mapper 接口
 * </p>
 *
 * @author yyy
 * @since 2018-08-13
 */
@Mapper
public interface HcPlanFinalAssemblyMapper extends BaseMapper<HcPlanFinalAssembly> {

    /**
     * 获取所有还没有发货的销售计划对应的总装集合
     * @return
     */
//    @Select("SELECT * FROM hc_plan_final_assembly WHERE sale_id IN (SELECT TID FROM base_taskinfo WHERE HWZT = 0) ORDER BY ass_end_date DESC")
//    @Select("SELECT * FROM hc_plan_final_assembly ORDER BY ass_end_date DESC")
    public List<HcPlanFinalAssembly> queryHcPlanFinalAssemblyList();


    public Date getMinAssemblyStartDate(@Param("assembly_ids") List<Long> assembly_ids);

}
